[dbo].[BAECartEventInsert]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@CartItemID	int	4
@EventCode	varchar(64)	64
@Title	varchar(128)	128
@RegistrantClass	varchar(64)	64
@RegistrantID	varchar(16)	16
@Complete	bit	1

SQL Script

create procedure [dbo].[BAECartEventInsert] @CartItemID as
int,
    @EventCode AS varchar(64),
    @Title AS varchar(128),
    @RegistrantClass AS varchar(64),
    @RegistrantID AS varchar(16),
    @Complete AS bit
AS
    INSERT INTO CartEvent
    (CartItemID,
    EventCode,
    Title,
    RegistrantClass,
    RegistrantID,
    Complete)
    VALUES
    (@CartItemID,
    @EventCode,
    @Title,
    @RegistrantClass,
    @RegistrantID,
    @Complete);

SELECT CAST(@@IDENTITY AS int) AS 'InsertedCartEvent';

GO